BEGIN TRANSACTION
GO
ALTER TABLE dbo.Invoice_Air ADD
	SumRemitNet numeric(15, 4) NOT NULL CONSTRAINT DF_Invoice_Air_SumRemitNet DEFAULT 0
GO
COMMIT

---------------------------

BEGIN TRANSACTION
GO
ALTER TABLE dbo.Invoice_AirRemit ADD
	RemitNet numeric(15, 4) NOT NULL CONSTRAINT DF_Invoice_AirRemit_RemitNet DEFAULT 0
GO
COMMIT

---------------------------

BEGIN TRANSACTION
GO
ALTER TABLE dbo.Invoice_Bank ADD
	SumRemitNet numeric(15, 4) NOT NULL CONSTRAINT DF_Invoice_Bank_SumRemitNet DEFAULT 0
GO
COMMIT

---------------------------

BEGIN TRANSACTION
GO
ALTER TABLE dbo.Invoice_BankRemit ADD
	RemitNet numeric(15, 4) NOT NULL CONSTRAINT DF_Invoice_BankRemit_RemitNet DEFAULT 0
GO
COMMIT

---------------------------

BEGIN TRANSACTION
GO
	UPDATE Invoice_Air SET SumRemitNet = SumRemit - SumFBC
GO
COMMIT

BEGIN TRANSACTION
GO
	UPDATE Invoice_AirRemit SET RemitNet = Remit - FBC
GO
COMMIT

BEGIN TRANSACTION
GO
	UPDATE Invoice_Bank SET SumRemitNet = SumRemit - SumFBC
GO
COMMIT

BEGIN TRANSACTION
GO
	UPDATE Invoice_BankRemit SET RemitNet = Remit - FBC
GO
COMMIT

-------------------------------------------------------------------------------------------------------------